UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJl4v8UdGmbLoT7ec/D1tGVZXEx3L1WdIRBpv/2YA7I='
WHERE
key_id = 'f3f56c59eccae5a79f8b9503e7c1048bc895e3f0ced7008bc1d2ea640dcadf91'
AND (
token = 'pJl4v8UdGmbLoT7ec/D1tGVZXEx3L1WdIRBpv/2YA7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)