UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HgaBQgorx0AhuJ5QI6atZlx8d5cY97oht6IAs9VN4dY=' 
WHERE 
  key_id = '0fc50ad49e6280450d39c1fe562d79b383243c56656cf0b0be97b4ee65761bca' 
  AND (
    token = 'HgaBQgorx0AhuJ5QI6atZlx8d5cY97oht6IAs9VN4dY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041