UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjtpM8Pgcne97knPXtyWT5tzKaSAS2eO8ap8G4x4+iY='
WHERE
key_id = 'f5bd7013be3618ece737f9cf2810399bf1de6b5d47046b15a8b4936454ba7a6b'
AND (
token = 'BjtpM8Pgcne97knPXtyWT5tzKaSAS2eO8ap8G4x4+iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)