UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K3xuJZCjimDGhfqMuhoEBkKTlC90A7rBYPanwjCCsy0='
WHERE
key_id = 'ec93d7b7902e9b1f8ebb8b3637ce1ccd5e85b5aac20105cb3382b01a0cc09845'
AND (
token = 'K3xuJZCjimDGhfqMuhoEBkKTlC90A7rBYPanwjCCsy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)