UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vg8k3gH7KJYA3eTx7/6UupORE9d6sgX0giY5ms/OVBI=' 
WHERE 
  key_id = '5110e5eb1ee1b2d10c34db55c40e94053993cc8f68f793f110a119cbd54e878a' 
  AND (
    token = 'Vg8k3gH7KJYA3eTx7/6UupORE9d6sgX0giY5ms/OVBI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047