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