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

Query time 0.00034