UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HnLcb3Zh2z9p+HD9kkyhehG9syhxMfEq4+Y+NeZgbqM=' 
WHERE 
  key_id = '02ef49464df1034baa5a30768b0970617263550294011d531c6541bbcd3b2694' 
  AND (
    token = 'HnLcb3Zh2z9p+HD9kkyhehG9syhxMfEq4+Y+NeZgbqM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029