UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E/lTc65WElh7pktre3kNCil+3wfUItzgXCit1w7sZJs='
WHERE
key_id = '8d561caa39e317223319533c681dc0a0c3b81d30755db0b72cf03c96d813aa22'
AND (
token = 'E/lTc65WElh7pktre3kNCil+3wfUItzgXCit1w7sZJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)