UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qQh5XwoaRbeeHk3BhXSqz77PWv1/L43+E/ah2sKqbKU='
WHERE
key_id = 'cfd6a3173556f5fb342066a4d3b6ae71bcad882a98375336a4fe5be7991f8788'
AND (
token = 'qQh5XwoaRbeeHk3BhXSqz77PWv1/L43+E/ah2sKqbKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)