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