UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqnD9oM1K8IKs89UGd86/Ovc4gUefoTMFSWv8E2ZouM='
WHERE
key_id = '2de9da4858f3a130fc92d16dc9de2ddfa497cd08ecde7b6e1ed8c3a8ff89c1e7'
AND (
token = 'nqnD9oM1K8IKs89UGd86/Ovc4gUefoTMFSWv8E2ZouM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)