UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uK4SKVoH8IFmkvAEzPs5FB8HIp0ZnVr+JglN85gafuw=' 
WHERE 
  key_id = '50a7d4ca796fbf6e5fafbd61740cebca9ca2f3b8220bb5057d4a6fbbcd2144fc' 
  AND (
    token = 'uK4SKVoH8IFmkvAEzPs5FB8HIp0ZnVr+JglN85gafuw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035