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