UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaSqyG2lKxPQKmvxCXMOWMvZEy9JQ35hZhmKbQipXmk='
WHERE
key_id = '127ce26957ead8f751aed9a71b68919a0627047da4674ae1f873b28ecb004fdd'
AND (
token = 'zaSqyG2lKxPQKmvxCXMOWMvZEy9JQ35hZhmKbQipXmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)