UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpU9D+eDj0OOJiOY6WowV4dU3Z0xFvWO4R4MXk6esx0='
WHERE
key_id = '2cf23aa688433ee2b63e499904ac7862592d77f76b748e96a38638a0f28e7c2c'
AND (
token = 'cpU9D+eDj0OOJiOY6WowV4dU3Z0xFvWO4R4MXk6esx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)