UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'D/m/tdnfZLwp3eLmO3oxmqHxRIavHVbGXS/q20L2Mpg=' 
WHERE 
  key_id = 'af1af9af0c42ba87255cf1078de1ddeac849f4f9b56bbaae75abf713dd3ad94e' 
  AND (
    token = 'D/m/tdnfZLwp3eLmO3oxmqHxRIavHVbGXS/q20L2Mpg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025