UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8i+xXFXQA1ucAxlY6bSj4jVko2mi9CZAUtykEdsp4E8=' 
WHERE 
  key_id = '068337e6314f70608806b33bf9b20d7dd74e1c9d01c77500ad1f861103de2d9e' 
  AND (
    token = '8i+xXFXQA1ucAxlY6bSj4jVko2mi9CZAUtykEdsp4E8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047