UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zlyktBJbdEZumTZ7TfcjHR8Tp1MPX7uNRKknjHe4QJY='
WHERE
key_id = '1ea8aca3ab52a57753c5e62892e3e2ee3a9b765a4714c842a4c8640ef95f296a'
AND (
token = 'zlyktBJbdEZumTZ7TfcjHR8Tp1MPX7uNRKknjHe4QJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)