UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jPsPPSk8kEq29v1tSc3i7gaIgeNeHolmNdh7K6v7dvw=' 
WHERE 
  key_id = '3ee59f7e2e9b737b0ba305faf4c1325cd5d58c510b43ae4bfe85e2f041eae4fe' 
  AND (
    token = 'jPsPPSk8kEq29v1tSc3i7gaIgeNeHolmNdh7K6v7dvw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036