UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Slal6aLIrC8nxKdrj8njF0c+cFdU4NPCAEQn99szS7s=' 
WHERE 
  key_id = '66bcc36ba9ea7b3bb77e4a77879d67a9d8e57c4a4c2508d3a5c7d7d279066abc' 
  AND (
    token = 'Slal6aLIrC8nxKdrj8njF0c+cFdU4NPCAEQn99szS7s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028