UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rU/Rj7Z9JFmb2NKznbY4F3Y/SlyiaqOFddj+vZ1j2TA=' 
WHERE 
  key_id = '897ae616d21f4513a21604bb8b1027ad817591fffba52277dcb3d5e3946699b4' 
  AND (
    token = 'rU/Rj7Z9JFmb2NKznbY4F3Y/SlyiaqOFddj+vZ1j2TA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047