UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zH7TTGREtfIMaA6ilJigoAl8DB4hCcJ82cD90IYVhTs='
WHERE
key_id = 'af4b87cf5548c0e29babc3ef65ef708da4a00107bb9e403429997dbf9004a8d0'
AND (
token = 'zH7TTGREtfIMaA6ilJigoAl8DB4hCcJ82cD90IYVhTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)