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