UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h+kOhNaPWsT2Hos7Nuv65SPjq/CJX5A5MXT3/8PKsNM=' 
WHERE 
  key_id = '2153bc63e68f60818c43d828914ddc0b5a33b75d15a570f7a41b9d72b5c9fa75' 
  AND (
    token = 'h+kOhNaPWsT2Hos7Nuv65SPjq/CJX5A5MXT3/8PKsNM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036