UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'auqsyIZV/2xYF4ARd4OA1xmzywE/2W0tVqR3sdZZGIM='
WHERE
key_id = 'e04f1919035ffc0faeef260fb749fdbac2a89245844dc38befd15fef89113ef1'
AND (
token = 'auqsyIZV/2xYF4ARd4OA1xmzywE/2W0tVqR3sdZZGIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)