UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xypXAls4sbfLynKOL/sacrmE2Ia5V2KC+7HRAb1EhFg=' 
WHERE 
  key_id = '0d8fc12d1600d9335fba4a324d275ebb1a5ef6414c6d8c50b68552e4ce9e3d8f' 
  AND (
    token = 'xypXAls4sbfLynKOL/sacrmE2Ia5V2KC+7HRAb1EhFg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029