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