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