UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BWWrtRzCaLYdccsny1fO3OxVMQ7pfU3ljiNDPbFCQ34='
WHERE
key_id = '39127d5c64590c64a08bbae659af1e4b37f16cca6102a0a5633ca778394eda20'
AND (
token = 'BWWrtRzCaLYdccsny1fO3OxVMQ7pfU3ljiNDPbFCQ34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)