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