UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mhCiiClIliL90N4GoEc2Q1K0jR8kZ9NBVGSmRzewhJU=' 
WHERE 
  key_id = '5a5686d32cd6caff2a5e06c1f6467b1a5fba0e53a1c49bdab40915a6f2e67338' 
  AND (
    token = 'mhCiiClIliL90N4GoEc2Q1K0jR8kZ9NBVGSmRzewhJU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043