UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'amscyMfHk95o3VTpcdGenO1Z8KjNc84BUgiEgQhiQQM='
WHERE
key_id = '8b35ffd561a2371ef247639fcdd46a9b19971b5ecb9c777714d3e85d35b2a487'
AND (
token = 'amscyMfHk95o3VTpcdGenO1Z8KjNc84BUgiEgQhiQQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)