UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9InUFCQ4XHUovGx0Ic2q8lDsL9Tc2GbBOInWm6rj0rE='
WHERE
key_id = '42539d367098d0957e341da81adc75c304c888fcac355b362c6a8944fd41ec1d'
AND (
token = '9InUFCQ4XHUovGx0Ic2q8lDsL9Tc2GbBOInWm6rj0rE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)