UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpqZYzneBBjyhfzstCh/8toWC7BzRAFu4D7TrZ9eYuU='
WHERE
key_id = 'd9de26b9db456b55544205a09d299cc2b92671f05b47362496f7b591a8577b7b'
AND (
token = 'HpqZYzneBBjyhfzstCh/8toWC7BzRAFu4D7TrZ9eYuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)