UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GEOPNNT1AQfKt4iumx32z83F4H9maeCrzeJln7w213s='
WHERE
key_id = '9cffa2441307e82a674939eac6bf334978c17d3670ce64babfa8cf6cc1007c70'
AND (
token = 'GEOPNNT1AQfKt4iumx32z83F4H9maeCrzeJln7w213s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)