UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AEVlMNQ0b3RgEViZARpEZv5eh1fwfYWWV/6e3RKy1cI='
WHERE
key_id = 'ff4dde3413ca2d0a3caf63f410541aef1617362fbe61c9aa9c2454afa34ed8a5'
AND (
token = 'AEVlMNQ0b3RgEViZARpEZv5eh1fwfYWWV/6e3RKy1cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)