UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ooB+3pEE4yfBKcdkLYHVcHOsklGF+s/DH92qCMJvcQM='
WHERE
key_id = 'cd4cc4e9a4e29f716be6809498c3bb9874fe1dda9dd7b52f39589fc67acca7b1'
AND (
token = 'ooB+3pEE4yfBKcdkLYHVcHOsklGF+s/DH92qCMJvcQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)