UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'as6Ye0gU8tUeWc/bX3mGzn/lAG3Trx9XF1Lec5m/ObI=' 
WHERE 
  key_id = 'b5b50768296f09bd434058df87d4b3af51d86952de70e98fb22a7b1ab6f7c465' 
  AND (
    token = 'as6Ye0gU8tUeWc/bX3mGzn/lAG3Trx9XF1Lec5m/ObI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022