UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAY3Z8V5/AFEv6c9edb5g0qBYBFzTrZkEU9hprD8/RE='
WHERE
key_id = 'f596e2ebb2af1924898ff53e517fb5f0859db7804d938617c9769c31786c1a96'
AND (
token = 'xAY3Z8V5/AFEv6c9edb5g0qBYBFzTrZkEU9hprD8/RE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)