UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hxLD/rRtNA1I5mG/ndpb291RZSwXaA0+bsOlvl+iDls=' 
WHERE 
  key_id = 'd99f2139570eba027da196e7b9b4726b4acaac5b17f3acfcc6861334adb7bbfb' 
  AND (
    token = 'hxLD/rRtNA1I5mG/ndpb291RZSwXaA0+bsOlvl+iDls=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00069